Tabela cnpn_DrugMF

Definicja tabeli cnpn_DrugMF

Name

cnpn_DrugMF

Code

cnpn_DrugMF

Comment

 


Lista kolumn tabeli cnpn_DrugMF

Name

Code

InsertDT

InsertDT

ReadDT

ReadDT

ExternalIdentifier

ExternalIdentifier

CommName

CommName

InternationalName

InternationalName

DoseCount

DoseCount

DoseUnit

DoseUnit

DrugForm

DrugForm

PackageMultiplier

PackageMultiplier

PackageName

PackageName

Producer

Producer

DddValue

DddValue

DddUnit

DddUnit

ABNList

ABNList

ATC

ATC

EAN

EAN

DrugKindCode

DrugKindCode

DrugKindName

DrugKindName

ApplicationWay

ApplicationWay

SideEffects

SideEffects

InReceptionary

InReceptionary

Active

Active

OutDBD

OutDBD

ActionType

ActionType


Kolumna InsertDT tabeli cnpn_DrugMF

Definicja kolumny InsertDT tabeli cnpn_DrugMF

Name

InsertDT

Code

InsertDT

Data Type

DATE

Mandatory

Yes

Comment

PL: Data wstawienia rekordu
EN: Insert date of record
DE: Das Date der Ansatzstelle fur den Rekord


Kolumna ReadDT tabeli cnpn_DrugMF

Definicja kolumny ReadDT tabeli cnpn_DrugMF

Name

ReadDT

Code

ReadDT

Data Type

DATE

Mandatory

No

Comment

 


Kolumna ExternalIdentifier tabeli cnpn_DrugMF

Definicja kolumny ExternalIdentifier tabeli cnpn_DrugMF

Name

ExternalIdentifier

Code

ExternalIdentifier

Data Type

VARCHAR2(10)

Mandatory

Yes

Comment

 


Kolumna CommName tabeli cnpn_DrugMF

Definicja kolumny CommName tabeli cnpn_DrugMF

Name

CommName

Code

CommName

Data Type

VARCHAR2(255)

Mandatory

Yes

Comment

 


Kolumna InternationalName tabeli cnpn_DrugMF

Definicja kolumny InternationalName tabeli cnpn_DrugMF

Name

InternationalName

Code

InternationalName

Data Type

VARCHAR2(255)

Mandatory

No

Comment

 


Kolumna DoseCount tabeli cnpn_DrugMF

Definicja kolumny DoseCount tabeli cnpn_DrugMF

Name

DoseCount

Code

DoseCount

Data Type

BINARY_DOUBLE

Mandatory

No

Comment

 


Kolumna DoseUnit tabeli cnpn_DrugMF

Definicja kolumny DoseUnit tabeli cnpn_DrugMF

Name

DoseUnit

Code

DoseUnit

Data Type

VARCHAR2(16)

Mandatory

No

Comment

 


Kolumna DrugForm tabeli cnpn_DrugMF

Definicja kolumny DrugForm tabeli cnpn_DrugMF

Name

DrugForm

Code

DrugForm

Data Type

VARCHAR2(255)

Mandatory

No

Comment

Forma leku


Kolumna PackageMultiplier tabeli cnpn_DrugMF

Definicja kolumny PackageMultiplier tabeli cnpn_DrugMF

Name

PackageMultiplier

Code

PackageMultiplier

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna PackageName tabeli cnpn_DrugMF

Definicja kolumny PackageName tabeli cnpn_DrugMF

Name

PackageName

Code

PackageName

Data Type

VARCHAR2(12)

Mandatory

No

Comment

 


Kolumna Producer tabeli cnpn_DrugMF

Definicja kolumny Producer tabeli cnpn_DrugMF

Name

Producer

Code

Producer

Data Type

NUMBER(3)

Mandatory

No

Comment

Warunkuje czy firma jest producentem


Kolumna DddValue tabeli cnpn_DrugMF

Definicja kolumny DddValue tabeli cnpn_DrugMF

Name

DddValue

Code

DddValue

Data Type

NUMBER(19,8)

Mandatory

No

Comment

Wartosc zdefiniowanej dawki dziennej (defined daily dose)


Kolumna DddUnit tabeli cnpn_DrugMF

Definicja kolumny DddUnit tabeli cnpn_DrugMF

Name

DddUnit

Code

DddUnit

Data Type

VARCHAR2(255)

Mandatory

No

Comment

Jednostka zdefiniowanej dawki dziennej (defined daily dose)


Kolumna ABNList tabeli cnpn_DrugMF

Definicja kolumny ABNList tabeli cnpn_DrugMF

Name

ABNList

Code

ABNList

Data Type

VARCHAR2(2)

Mandatory

No

Comment

 


Kolumna ATC tabeli cnpn_DrugMF

Definicja kolumny ATC tabeli cnpn_DrugMF

Name

ATC

Code

ATC

Data Type

VARCHAR2(12)

Mandatory

No

Comment

 


Kolumna EAN tabeli cnpn_DrugMF

Definicja kolumny EAN tabeli cnpn_DrugMF

Name

EAN

Code

EAN

Data Type

VARCHAR2(16)

Mandatory

No

Comment

 


Kolumna DrugKindCode tabeli cnpn_DrugMF

Definicja kolumny DrugKindCode tabeli cnpn_DrugMF

Name

DrugKindCode

Code

DrugKindCode

Data Type

VARCHAR2(12)

Mandatory

No

Comment

 


Kolumna DrugKindName tabeli cnpn_DrugMF

Definicja kolumny DrugKindName tabeli cnpn_DrugMF

Name

DrugKindName

Code

DrugKindName

Data Type

VARCHAR2(255)

Mandatory

No

Comment

 


Kolumna ApplicationWay tabeli cnpn_DrugMF

Definicja kolumny ApplicationWay tabeli cnpn_DrugMF

Name

ApplicationWay

Code

ApplicationWay

Data Type

CLOB

Mandatory

No

Comment

 


Kolumna SideEffects tabeli cnpn_DrugMF

Definicja kolumny SideEffects tabeli cnpn_DrugMF

Name

SideEffects

Code

SideEffects

Data Type

VARCHAR2(255)

Mandatory

No

Comment

 


Kolumna InReceptionary tabeli cnpn_DrugMF

Definicja kolumny InReceptionary tabeli cnpn_DrugMF

Name

InReceptionary

Code

InReceptionary

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna Active tabeli cnpn_DrugMF

Definicja kolumny Active tabeli cnpn_DrugMF

Name

Active

Code

Active

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna OutDBD tabeli cnpn_DrugMF

Definicja kolumny OutDBD tabeli cnpn_DrugMF

Name

OutDBD

Code

OutDBD

Data Type

CLOB

Mandatory

No

Comment

 


Kolumna ActionType tabeli cnpn_DrugMF

Definicja kolumny ActionType tabeli cnpn_DrugMF

Name

ActionType

Code

ActionType

Data Type

VARCHAR2(3)

Mandatory

Yes

Comment